﻿/********************************************************************************************************************
* Author:	Christos Polydorou																						*
* Email:	std04237@di.uoa.gr																						*
* Purpose:	This script is used in order to create the stored procedure "usp_getusers" that returns the usernames	*
* and the ids of all registered users.																				*
********************************************************************************************************************/

CREATE PROCEDURE [dbo].[usp_getusers]
AS
	SELECT id, username
	FROM Users
RETURN 0